nested loop
英 [ˈnestɪd luːp]
美 [ˈnestɪd luːp]
网络 嵌套循环; 嵌套循环连接; 嵌套连接; 嵌套循環; 嵌套循环方法
双语例句
- This registry variable causes the optimizer to favor nested loop joins to join the list of values, using the table that contributes the IN list as the inner table in the join.
这个注册表变量会导致优化器优先使用嵌套循环连接来连接值列表，使用为IN列表提供值的表作为连接的内部表。 - This type of access path is referred to as a nested loop join ( NLJOIN) with sort composite.
这种类型的访问路径被称为使用复合排序的嵌套循环联接（NLJOIN）。 - So when compared to a nested loop join, the merge scan join may incur the cost for sorting the inputs.
因此，当与嵌套循环联接比较时，合并扫描联接可能对于排序输入产生成本。 - The2 tables in QB2 are joined with nested loop join ( NLJ)
QB2中两个表用嵌套循环（NLJ）连接。 - Here's what happens at execution time for the first leg of the nested loop join
以下是在执行嵌套循环联接的第一步时将发生的操作 - Join plan directives that force optimizer to use the designated join method to join tables in the query, either nested loop join, sort merge join, or dynamic hash join.
连接计划指示，强制优化器使用指定的连接方法来连接查询中的表，要么是嵌套循环连接、分类合并连接，要么是动态哈希连接。 - Also, the nested loop join method is used to join the source and target tables.
而且，嵌套循环联接方法用于联接源表与目标表。 - In general, a nested loop join with sort composite is favored by the optimizer if the inner index is well-clustered and the inner table is expected to be probed many times.
一般来说，如果内部索引是良好的集群且预测内部表被多次探测，则使用复合排序的嵌套循环联将受到优化器的青睐。 - In the previous section you learned about one type of access method, index scan ( IXSCAN), and one type of join method, nested loop join ( NLJOIN).
在之前的部分您已经了解了一种类型的访问方法，即索引扫描（IXSCAN），和一种类型的联接方法，即嵌套循环联接（NLJOIN）。 - The result of that join operation then becomes the first input to the second join operation ( also a nested loop join).
该联接操作的结果就成为第一个联接操作输入到第二个联接操作（也是一个嵌套循环联接）。 - It contains a nested loop that calls exp(), cos(), and sin(), followed by a loop that calls sin() and sqrt().
它包含了一个嵌套的循环，该循环会调用exp（）、cos（）以及sin（），接下来是一个调用sin（）和sqrt（）的循环。 - Because of how nested loop joins work, the second leg ( there are four nodes) is executed per outer table record.
因为嵌套循环联接的工作方式，所以每隔一个外部表记录执行第二步（共4个节点）。 - How do you know that the nested loop method is the right way to join these tables?
如何知道嵌套循环方法是连接这些表的正确方法？ - As previously stated, ordered input is essential to a merge scan join, but it is not required for nested loop joins.
如前所述，按顺序的输入对于合并扫描联接是必不可少的，但其无需嵌套循环联接。 - If the query includes a join, the optimizer must determine the join plan ( hash, sort merge, or nested loop), and the order in which tables are evaluated or joined.
如果该查询包含了连接，那么优化器就必须确定连接计划（hash、sortmerge或nestedloop），以及评估或连接表的次序。 - This is a lot faster than a nested loop join of two table scans without any index usage.
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。 - For each row, the nested loop join ( NLJOIN) operator passes a pointer to the corresponding XML document to the XSCAN operator.
对于每一行，嵌套循环连接（NLJOIN）操作符把指向相应的XML文档的指针传递给XSCAN操作符。 - However, the benefit of the merge scan join is that the inner table does not have to be scanned repeatedly as it does for nested loop joins.
然而，合并扫描联接的好处是不必反复地扫描内部表因为其为嵌套循环联接工作。 - The only interesting thing now is a nested loop.
唯一有趣的是现在是一个嵌套循环。 - Loop transformation is the basic way to maximization parallelism, but it doesn't work in the case of non-perfect nested loop with complicated control flow.
在并行编译中，循环变换是开发程序并行度的主要方法，但存在复杂控制流的非紧密嵌套循环往往无法得到有效的并行化。 - In my experience, it will usually be a particular inner or nested loop, or a call to some third party library methods, which is the main culprit for running the program slow.
以我的经验来看，导致程序运行速度慢得罪魁祸首可能就是某个内部或嵌套循环，也可能是对第三方库函数的调用。 - In it you will find the difference between a hash map join and a nested loop join and which is better.
你会发现hashmapjoin与nestedloopjoin的区别，同时也可以判定出哪个更好一些。 - The realization of mapping a class of nested loop algorithms to linear systolic array is studied.
研究了一类多重循环算法的线性脉动阵列实现。 - Optimization of Load Balance Based on Nested Loop Parallelization
基于多层循环并行化的负载平衡优化 - A Time Complexity Analysis Method for Nested Loop Structure
一种循环嵌套结构的时间复杂性分析方法 - Control mechanism for software pipelining on nested loop
支持多重循环软件流水的循环控制机制 - This paper comes out the features of non-perfect nested loop and its useful transformation in parallel compiler on the basis of the experience of implement of AFT which is a automatic parallelize system and analysis of some benchmark.
文章结合分析Benchmark和实现自动并行化系统AFT中复杂非紧密嵌套循环变换的经验，给出复杂非紧密嵌套循环变换的特点及其在并行编译中的应用。 - Besides, we choose the improved nested loop join algorithm to deal with join operation in memory-constrained environment.
针对内存受限，采用了改进的嵌套循环连接算法。 - However, it is hard to predict the hardware performance of code segment, especially the nested loop as the performance differences of hardware circuit converted by different design method, are very distinct. It is a difficult problem to find out a good partition method.
然而由于程序代码尤其是嵌套循环转换后硬件电路性能差别较大，很难估算出程序代码在硬件上执行可能达到的性能，因此确定一个好的软硬件代码划分比较困难。